In this
lesson, you will learn how to:
1. Identify and use the Order of Operations to evaluate formulas.
2. Audit a Formula with the Watch Window and keep an eye on selected
Cell(s).
3. Use TEXT Functions to get data out of a STRING: LEFT, MID, TRIM.
4. Use a Formula in a Formula: Create a NESTED Function.
This lesson introduces the Sparkline and Home
Ribbons.
1.
Insert -> Sparklines -> Line, page 178
2.
Sparkline Tools -> Design->Type -> Column, page 180
3.
Sparkline Tools -> Design->Style, page 181
4.
Sparkline Tools -> Design->Show -> Markers, page 182
5.
Sparkline Tools -> Design->Style -> Marker Color, page 183
6.
Sparkline Tools -> Design->Group -> Axis, page 184
7.
Home -> Cells -> Format->Rename Sheet, page 185
8.
Insert->Links->Hyperlink, page 193 |
|
|
|
